Introduction of Excel
- An overview of the Screen
- Navigation and Basic Concepts of Spreadsheet
- Excel Rows and Columns
- Verious Selection Techniques
- How to save your Work in excel
- Enter text and Number in a Cell
- How to Edit text in a cell
- How to Center text and Numbers
- Font Formatting in Excel
- How to Change the Color of a Cell
- Currency Symbols in Excel
- How to use Autofill in excel
- Adding Simple Addition formula
- The Sum Function in excel
- How to use Paste Special
- How to Multiply in Excel
- How to Marge cells
- How to add a comment to a cell
Customizing Excel
- Coustomizing the Ribbon
- Using and Customizing Auto Currect
- Changing Excel Default Options
Formating, Proofing and Functions
- Currency Formate
- Formate Pointer
- Formating Dates
- Custom and Special Formats
- Formatting Cell With Number Formats, Allignment, Borders, etc.
- BAsic Conditional Formatting
- Use Basic Functions - Sum, Average, Max, Min, Count, Counta
- Absolute, Mixed and Relative Referencing
- SumIf, SumIfs, CountIf, CountIfs, AverageIf, AverageIfs, AND, OR, NOT.
Logical Functions and Data Validation
- If Function
- How to Fix Errors - If Error
- Nasted If
- Complex if and Functions
- Number, Date & Time Validation
- Text and List Validation
- Custom validations bassed on Formula on a Cell
- Dynamic Dropdown List Creation using Data validation - Dependency List
- Using PMT Functios - PMT, PPMT, IPMT, PV, FV, NPer, Per, Rate etc.
Lookup Functions
- VLookup / HLookup
- Index and Match
- Creating Smooth User Interface Using Lookup
- Nasted VLookup
- Reverse Lookup Using Choose Function
- Worksheet Linking Using Indirect
|
Protecting Excel
- File Level Protection
- Workbook Protection
- Worksheet Protection
Text Functions
- Upper, Lower, Proper
- Left, Mid, Right
- Trim, Len,Exact
- Concatenate
- Find, Substitute
Date and Time Functions
- Today, Now
- Day, Month, Year
- Date, DateIf, DateAdd
- EOMonth, Weekday
Advance Paste Special Techniques
- Past Formula, Past Formates
- Past Validations
- Transpose Tables
Shorting and Filtering
- Filtering on Text, Numbers and Colors
- Caustom Sort
- Sorting Options
- Advance Filter
Printing Workbooks
- Setting Up Print Area
- Customizing Headers and Footers
- Designing the Structure of a Template
- Print-Titles Rows/Columns
Pivot Tables
- Creating Simple Pivot table
- Basic and Advance Value Field Setting
- Classic Pivot Table
- Choosing Field
- Filtering Pivot table
- Modifying Pivot table
- Grouping based on Numbers and Dates
- Calculated Field & Calculated Items
- Arrays Functions
- What are the Array Formulas, Use of the Array Formulas
- Basic Exp. of Arrays (Using Ctrl+Shift+Enter)
- Array with If, Len, and Mid Functions Formulas
- Array with Looup Functions
Charts and Slicers
- Various Charts i.e. Bar Charts / Pie Charts / Line Charts
- Using Slicers, Filter data with Slicers
- Mange Primary And Secondary Axis
|
